package com.link.base.base.system.service;

import com.link.base.base.system.model.ConfigDb;
import com.link.core.basic.service.BasicService;

import java.util.List;
import java.util.Map;

/**
 * 查询系统数据库表（仅包含查询功能）
 *
 * @author LiYang
 * @date 20190820
 */
public interface ConfigDbService extends BasicService<ConfigDb> {

    /**
     * 查询数据库表
     *
     * @author LiYang
     * @date 20190820
     * @param configDb
     * @return
     * @throws Exception
     */
    public List<Map<String, Object>> queryMySqlTable(ConfigDb configDb) throws Exception;

    /**
     * 查询数据库表字段
     *
     * @author LiYang
     * @date 20190820
     * @param configDb
     * @return
     * @throws Exception
     */
    public List<Map<String, Object>> queryMySqlTableColumn(ConfigDb configDb) throws Exception;

    /**
     * 根据关键字，模糊查询表或列
     *
     * @author LiYang
     * @date 20190820
     * @param configDb
     * @return
     * @throws Exception
     */
    public List<Map<String, Object>> fuzzyQueryMySql(ConfigDb configDb) throws Exception;
}
